<html>
<head>
<title>Docs For Class PHPExcel_Worksheet</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">
</head>
<body>

<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
  <tr>
    <td class="header_top">PHPExcel_Worksheet</td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
  <tr>
    <td class="header_menu">
        
                                                                                                                                                                                                                                                                                                                                                                                                                                
                                                                                                              		  [ <a href="../classtrees_PHPExcel_Worksheet.html" class="menu">class tree: PHPExcel_Worksheet</a> ]
		  [ <a href="../elementindex_PHPExcel_Worksheet.html" class="menu">index: PHPExcel_Worksheet</a> ]
		  	    [ <a href="../elementindex.html" class="menu">all elements</a> ]
    </td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
</table>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="200" class="menu">
	<div id="todolist">
			<p><a href="../todolist.html">Todo List</a></p>
	</div>
      <b>Packages:</b><br />
              <a href="../li_PHPExcel.html">PHPExcel</a><br />
              <a href="../li_JAMA.html">JAMA</a><br />
              <a href="../li_Math_Stats.html">Math_Stats</a><br />
              <a href="../li_PHPExcel_CachedObjectStorage.html">PHPExcel_CachedObjectStorage</a><br />
              <a href="../li_PHPExcel_Calculation.html">PHPExcel_Calculation</a><br />
              <a href="../li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
              <a href="../li_PHPExcel_Chart.html">PHPExcel_Chart</a><br />
              <a href="../li_PHPExcel_Chart_Renderer.html">PHPExcel_Chart_Renderer</a><br />
              <a href="../li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
              <a href="../li_PHPExcel_Reader_Excel5.html">PHPExcel_Reader_Excel5</a><br />
              <a href="../li_PHPExcel_Reader_Excel2007.html">PHPExcel_Reader_Excel2007</a><br />
              <a href="../li_PHPExcel_RichText.html">PHPExcel_RichText</a><br />
              <a href="../li_PHPExcel_Settings.html">PHPExcel_Settings</a><br />
              <a href="../li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
              <a href="../li_PHPExcel_Shared_Escher.html">PHPExcel_Shared_Escher</a><br />
              <a href="../li_PHPExcel_Shared_OLE.html">PHPExcel_Shared_OLE</a><br />
              <a href="../li_PHPExcel_Shared_Trend.html">PHPExcel_Shared_Trend</a><br />
              <a href="../li_PHPExcel_Shared_ZipArchive.html">PHPExcel_Shared_ZipArchive</a><br />
              <a href="../li_PHPExcel_Style.html">PHPExcel_Style</a><br />
              <a href="../li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
              <a href="../li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
              <a href="../li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
              <a href="../li_PHPExcel_Writer_Excel5.html">PHPExcel_Writer_Excel5</a><br />
              <a href="../li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
            <br /><br />
                        <b>Files:</b><br />
      	  <div class="package">
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---AutoFilter.php.html">		AutoFilter.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---BaseDrawing.php.html">		BaseDrawing.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---CellIterator.php.html">		CellIterator.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---AutoFilter---Column.php.html">		Column.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---ColumnDimension.php.html">		ColumnDimension.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---HeaderFooter.php.html">		HeaderFooter.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---HeaderFooterDrawing.php.html">		HeaderFooterDrawing.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---MemoryDrawing.php.html">		MemoryDrawing.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---PageMargins.php.html">		PageMargins.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---PageSetup.php.html">		PageSetup.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---Protection.php.html">		Protection.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---Row.php.html">		Row.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---RowDimension.php.html">		RowDimension.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---RowIterator.php.html">		RowIterator.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---AutoFilter---Column---Rule.php.html">		Rule.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---SheetView.php.html">		SheetView.php
		</a><br>
			<a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet.php.html">		Worksheet.php
		</a><br>
	  </div><br />
      
      
            <b>Classes:</b><br />
        <div class="package">
		    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_AutoFilter.html">PHPExcel_Worksheet_AutoFilter</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_AutoFilter_Column.html">PHPExcel_Worksheet_AutoFilter_Column</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_AutoFilter_Column_Rule.html">PHPExcel_Worksheet_AutoFilter_Column_Rule</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_BaseDrawing.html">PHPExcel_Worksheet_BaseDrawing</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_CellIterator.html">PHPExcel_Worksheet_CellIterator</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooterDrawing.html">PHPExcel_Worksheet_HeaderFooterDrawing</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_MemoryDrawing.html">PHPExcel_Worksheet_MemoryDrawing</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Row.html">PHPExcel_Worksheet_Row</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowDimension.html">PHPExcel_Worksheet_RowDimension</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowIterator.html">PHPExcel_Worksheet_RowIterator</a><br />
	    		<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_SheetView.html">PHPExcel_Worksheet_SheetView</a><br />
	  </div>
                </td>
    <td>
      <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

<h1>Class: PHPExcel_Worksheet</h1>
Source Location: /PHPExcel/Worksheet.php<br /><br />


<table width="100%" border="0">
<tr><td valign="top">

<h3><a href="#class_details">Class Overview</a></h3>
<pre></pre><br />
<div class="description">PHPExcel_Worksheet</div><br /><br />
<h4>Author(s):</h4>
<ul>
        </ul>




      
  

<h4>Copyright:</h4>
<ul>
  <li>Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)</li>
</ul>
                <p class="implements">
            Implements interfaces:
            <ul>
                <li><a href="../PHPExcel/PHPExcel_IComparable.html">PHPExcel_IComparable</a></li>            </ul>
        </p>
        
</td>


<td valign="top">
<h3><a href="#class_consts">Constants</a></h3>
<ul>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constBREAK_COLUMN">BREAK_COLUMN</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constBREAK_NONE">BREAK_NONE</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constBREAK_ROW">BREAK_ROW</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constSHEETSTATE_HIDDEN">SHEETSTATE_HIDDEN</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constSHEETSTATE_VERYHIDDEN">SHEETSTATE_VERYHIDDEN</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constSHEETSTATE_VISIBLE">SHEETSTATE_VISIBLE</a></li>
  </ul>
</td>

<td valign="top">
<h3><a href="#class_methods">Methods</a></h3>
<ul>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodaddChart">addChart</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#method__construct">__construct</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcalculateColumnWidths">calculateColumnWidths</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcalculateWorksheetDataDimension">calculateWorksheetDataDimension</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcalculateWorksheetDimension">calculateWorksheetDimension</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcellExists">cellExists</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcellExistsByColumnAndRow">cellExistsByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodconditionalStylesExists">conditionalStylesExists</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcopy">copy</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methoddataValidationExists">dataValidationExists</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methoddisconnectCells">disconnectCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodduplicateConditionalStyle">duplicateConditionalStyle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodduplicateStyle">duplicateStyle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodduplicateStyleArray">duplicateStyleArray</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodextractSheetTitle">extractSheetTitle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodfreezePane">freezePane</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodfreezePaneByColumnAndRow">freezePaneByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodfromArray">fromArray</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgarbageCollect">garbageCollect</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetActiveCell">getActiveCell</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetAutoFilter">getAutoFilter</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetBreaks">getBreaks</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCell">getCell</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCellByColumnAndRow">getCellByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCellCacheController">getCellCacheController</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCellCollection">getCellCollection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartByIndex">getChartByIndex</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartByName">getChartByName</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartCollection">getChartCollection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartCount">getChartCount</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartNames">getChartNames</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetColumnDimension">getColumnDimension</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetColumnDimensionByColumn">getColumnDimensionByColumn</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetColumnDimensions">getColumnDimensions</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetComment">getComment</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCommentByColumnAndRow">getCommentByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetComments">getComments</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetConditionalStyles">getConditionalStyles</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetConditionalStylesCollection">getConditionalStylesCollection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDataValidation">getDataValidation</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDataValidationCollection">getDataValidationCollection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDefaultColumnDimension">getDefaultColumnDimension</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDefaultRowDimension">getDefaultRowDimension</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDefaultStyle">getDefaultStyle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDrawingCollection">getDrawingCollection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetFreezePane">getFreezePane</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHashCode">getHashCode</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHeaderFooter">getHeaderFooter</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestColumn">getHighestColumn</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestDataColumn">getHighestDataColumn</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestDataRow">getHighestDataRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestRow">getHighestRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestRowAndColumn">getHighestRowAndColumn</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHyperlink">getHyperlink</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHyperlinkCollection">getHyperlinkCollection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetInvalidCharacters">getInvalidCharacters</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetMergeCells">getMergeCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetPageMargins">getPageMargins</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetPageSetup">getPageSetup</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetParent">getParent</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetPrintGridlines">getPrintGridlines</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetProtectedCells">getProtectedCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetProtection">getProtection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetRightToLeft">getRightToLeft</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetRowDimension">getRowDimension</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetRowDimensions">getRowDimensions</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetRowIterator">getRowIterator</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetSelectedCell">getSelectedCell</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetSelectedCells">getSelectedCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetSheetState">getSheetState</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetSheetView">getSheetView</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetShowGridlines">getShowGridlines</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetShowRowColHeaders">getShowRowColHeaders</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetShowSummaryBelow">getShowSummaryBelow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetShowSummaryRight">getShowSummaryRight</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetStyle">getStyle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetStyleByColumnAndRow">getStyleByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetStyles">getStyles</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetTabColor">getTabColor</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetTitle">getTitle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodhyperlinkExists">hyperlinkExists</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodinsertNewColumnBefore">insertNewColumnBefore</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodinsertNewColumnBeforeByIndex">insertNewColumnBeforeByIndex</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodinsertNewRowBefore">insertNewRowBefore</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodisTabColorSet">isTabColorSet</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodmergeCells">mergeCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodmergeCellsByColumnAndRow">mergeCellsByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodnamedRangeToArray">namedRangeToArray</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodprotectCells">protectCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodprotectCellsByColumnAndRow">protectCellsByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodrangeToArray">rangeToArray</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodrebindParent">rebindParent</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodrefreshColumnDimensions">refreshColumnDimensions</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodrefreshRowDimensions">refreshRowDimensions</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveAutoFilter">removeAutoFilter</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveColumn">removeColumn</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveColumnByIndex">removeColumnByIndex</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveConditionalStyles">removeConditionalStyles</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveRow">removeRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodresetTabColor">resetTabColor</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetAutoFilter">setAutoFilter</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetAutoFilterByColumnAndRow">setAutoFilterByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetBreak">setBreak</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetBreakByColumnAndRow">setBreakByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetCellValue">setCellValue</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetCellValueByColumnAndRow">setCellValueByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetCellValueExplicit">setCellValueExplicit</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetCellValueExplicitByColumnAndRow">setCellValueExplicitByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetComments">setComments</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetConditionalStyles">setConditionalStyles</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetDataValidation">setDataValidation</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetDefaultStyle">setDefaultStyle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetHeaderFooter">setHeaderFooter</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetHyperlink">setHyperlink</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetMergeCells">setMergeCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetPageMargins">setPageMargins</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetPageSetup">setPageSetup</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetPrintGridlines">setPrintGridlines</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetProtection">setProtection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetRightToLeft">setRightToLeft</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSelectedCell">setSelectedCell</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSelectedCellByColumnAndRow">setSelectedCellByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSelectedCells">setSelectedCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSharedStyle">setSharedStyle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSheetState">setSheetState</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSheetView">setSheetView</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetShowGridlines">setShowGridlines</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetShowRowColHeaders">setShowRowColHeaders</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetShowSummaryBelow">setShowSummaryBelow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetShowSummaryRight">setShowSummaryRight</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetTitle">setTitle</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodshrinkRangeToFit">shrinkRangeToFit</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsortCellCollection">sortCellCollection</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodtoArray">toArray</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunfreezePane">unfreezePane</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunmergeCells">unmergeCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunmergeCellsByColumnAndRow">unmergeCellsByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunprotectCells">unprotectCells</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunprotectCellsByColumnAndRow">unprotectCellsByColumnAndRow</a></li>
    <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#method__clone">__clone</a></li>
  </ul>
</td>

</tr></table>
<hr />

<table width="100%" border="0"><tr>






</tr></table>
<hr />

<a name="class_details"></a>
<h3>Class Details</h3>
<div class="tags">
[line 36]<br />
PHPExcel_Worksheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>copyright:</b>&nbsp;&nbsp;</td><td>Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)</td>
  </tr>
</table>
</div>
</div><br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />


<hr />
<a name="class_methods"></a>
<h3>Class Methods</h3>
<div class="tags">
  <hr />
	<a name="methodextractSheetTitle"></a>
	<h3>static method extractSheetTitle <span class="smalllinenumber">[line 2568]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>static mixed extractSheetTitle(
string
$pRange, [bool
$returnRange = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Extract worksheet title from range.<br /><br /><p>Example: extractSheetTitle(&quot;testSheet!A1&quot;) ==&gt; 'A1'  Example: extractSheetTitle(&quot;'testSheet 1'!A1&quot;, true) ==&gt; array('testSheet 1', 'A1');</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Range to extract title from</td>
      </tr>
          <tr>
        <td class="type">bool&nbsp;&nbsp;</td>
        <td><b>$returnRange</b>&nbsp;&nbsp;</td>
        <td>Return range? (see example)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetInvalidCharacters"></a>
	<h3>static method getInvalidCharacters <span class="smalllinenumber">[line 402]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>static array getInvalidCharacters(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get array of invalid characters for sheet title<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>

  <hr />
	<a name="methodaddChart"></a>
	<h3>method addChart <span class="smalllinenumber">[line 528]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Chart/PHPExcel_Chart.html">PHPExcel_Chart</a> addChart(
[PHPExcel_Chart
$pChart = null], [int|null
$iChartIndex = null])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Add chart<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Chart/PHPExcel_Chart.html">PHPExcel_Chart</a>&nbsp;&nbsp;</td>
        <td><b>$pChart</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
          <tr>
        <td class="type">int|null&nbsp;&nbsp;</td>
        <td><b>$iChartIndex</b>&nbsp;&nbsp;</td>
        <td>Index where chart should go (0,1,..., or null for last)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="method__construct"></a>
	<h3>constructor __construct <span class="smalllinenumber">[line 334]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Worksheet __construct(
[PHPExcel
$pParent = null], [string
$pTitle = 'Worksheet'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Create a new worksheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a>&nbsp;&nbsp;</td>
        <td><b>$pParent</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pTitle</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodcalculateColumnWidths"></a>
	<h3>method calculateColumnWidths <span class="smalllinenumber">[line 677]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Worksheet; calculateColumnWidths(
[boolean
$calculateMergeCells = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Calculate widths for auto-size columns<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$calculateMergeCells</b>&nbsp;&nbsp;</td>
        <td>Calculate merge cell width</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodcalculateWorksheetDataDimension"></a>
	<h3>method calculateWorksheetDataDimension <span class="smalllinenumber">[line 665]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string calculateWorksheetDataDimension(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Calculate worksheet data dimension<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>String containing the dimension of this worksheet that actually contain data</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodcalculateWorksheetDimension"></a>
	<h3>method calculateWorksheetDimension <span class="smalllinenumber">[line 654]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string calculateWorksheetDimension(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Calculate worksheet dimension<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>String containing the dimension of this worksheet</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodcellExists"></a>
	<h3>method cellExists <span class="smalllinenumber">[line 1184]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean cellExists(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Cell at a specific coordinate exists?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td>Coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodcellExistsByColumnAndRow"></a>
	<h3>method cellExistsByColumnAndRow <span class="smalllinenumber">[line 1231]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean cellExistsByColumnAndRow(
[string
$pColumn = 0], [string
$pRow = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Cell at a specific coordinate by using numeric cell coordinates exists?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodconditionalStylesExists"></a>
	<h3>method conditionalStylesExists <span class="smalllinenumber">[line 1367]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean conditionalStylesExists(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Do conditional styles exist for this cell?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodcopy"></a>
	<h3>method copy <span class="smalllinenumber">[line 2762]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> copy(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Copy worksheet (!= clone!)<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methoddataValidationExists"></a>
	<h3>method dataValidationExists <span class="smalllinenumber">[line 2678]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean dataValidationExists(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Data validation at a specific coordinate exists?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methoddisconnectCells"></a>
	<h3>method disconnectCells <span class="smalllinenumber">[line 379]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void disconnectCells(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Disconnect all cells from this PHPExcel_Worksheet object,<br /><br /><p>typically so that the worksheet object can be unset</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodduplicateConditionalStyle"></a>
	<h3>method duplicateConditionalStyle <span class="smalllinenumber">[line 1513]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> duplicateConditionalStyle(
[array
$pCellStyle = null], [string
$pRange = ''])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Duplicate conditional style to a range of cells<br /><br /><p>Please note that this will overwrite existing cell styles for cells in range!</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
      </tr>
          <tr>
        <td class="type">array&nbsp;&nbsp;</td>
        <td><b>$pCellStyle</b>&nbsp;&nbsp;</td>
        <td>of PHPExcel_Style_Conditional    $pCellStyle    Cell style to duplicate</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodduplicateStyle"></a>
	<h3>method duplicateStyle <span class="smalllinenumber">[line 1449]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> duplicateStyle(
[PHPExcel_Style
$pCellStyle = null], [string
$pRange = ''])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Duplicate cell style to a range of cells<br /><br /><p>Please note that this will overwrite existing cell styles for cells in range!</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a>&nbsp;&nbsp;</td>
        <td><b>$pCellStyle</b>&nbsp;&nbsp;</td>
        <td>Cell style to duplicate</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodduplicateStyleArray"></a>
	<h3>method duplicateStyleArray <span class="smalllinenumber">[line 1573]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> duplicateStyleArray(
[array
$pStyles = null], [string
$pRange = ''], [boolean
$pAdvanced = true])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Duplicate cell style array to a range of cells<br /><br /><p>Please note that this will overwrite existing cell styles for cells in range,  if they are in the styles array. For example, if you decide to set a range of  cells to font bold, only include font bold in the styles array.</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
  </tr>
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">array&nbsp;&nbsp;</td>
        <td><b>$pStyles</b>&nbsp;&nbsp;</td>
        <td>Array containing style information</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pAdvanced</b>&nbsp;&nbsp;</td>
        <td>Advanced mode for setting borders.</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfreezePane"></a>
	<h3>method freezePane <span class="smalllinenumber">[line 1912]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> freezePane(
[string
$pCell = ''])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Freeze Pane<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCell</b>&nbsp;&nbsp;</td>
        <td>Cell (i.e. A2)                                     Examples:                                         A2 will freeze the rows above cell A2 (i.e row 1)                                         B1 will freeze the columns to the left of cell B1 (i.e column A)                                         B2 will freeze the rows above and to the left of cell A2                                             (i.e row 1 and column A)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfreezePaneByColumnAndRow"></a>
	<h3>method freezePaneByColumnAndRow <span class="smalllinenumber">[line 1933]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> freezePaneByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Freeze Pane by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodfromArray"></a>
	<h3>method fromArray <span class="smalllinenumber">[line 2338]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> fromArray(
[array
$source = null], [mixed
$nullValue = null], [string
$startCell = 'A1'], [boolean
$strictNullComparison = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Fill worksheet from values in array<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">array&nbsp;&nbsp;</td>
        <td><b>$source</b>&nbsp;&nbsp;</td>
        <td>Source array</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$nullValue</b>&nbsp;&nbsp;</td>
        <td>Value in source array that stands for blank cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$startCell</b>&nbsp;&nbsp;</td>
        <td>Insert array starting from this cell address as the top left coordinate</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$strictNullComparison</b>&nbsp;&nbsp;</td>
        <td>Apply strict comparison when testing for null values in the array</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgarbageCollect"></a>
	<h3>method garbageCollect <span class="smalllinenumber">[line 2504]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> garbageCollect(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Run PHPExcel garabage collector.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetActiveCell"></a>
	<h3>method getActiveCell <span class="smalllinenumber">[line 2235]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getActiveCell(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get active cell<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Example: 'A1'</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetAutoFilter"></a>
	<h3>method getAutoFilter <span class="smalllinenumber">[line 1837]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_AutoFilter.html">PHPExcel_Worksheet_AutoFilter</a> getAutoFilter(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get Autofilter<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetBreaks"></a>
	<h3>method getBreaks <span class="smalllinenumber">[line 1620]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array[] getBreaks(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get breaks<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetCell"></a>
	<h3>method getCell <span class="smalllinenumber">[line 1087]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> getCell(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get cell at a specific coordinate<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Cell that was found</td>
  </tr>
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td>Coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetCellByColumnAndRow"></a>
	<h3>method getCellByColumnAndRow <span class="smalllinenumber">[line 1157]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> getCellByColumnAndRow(
[string
$pColumn = 0], [string
$pRow = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get cell at a specific coordinate by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Cell that was found</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetCellCacheController"></a>
	<h3>method getCellCacheController <span class="smalllinenumber">[line 392]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_CachedObjectStorage_xxx getCellCacheController(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Return the cache controller for the cell collection<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetCellCollection"></a>
	<h3>method getCellCollection <span class="smalllinenumber">[line 435]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Cell[] getCellCollection(
[boolean
$pSorted = true])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get collection of cells<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pSorted</b>&nbsp;&nbsp;</td>
        <td>Also sort the cell collection?</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetChartByIndex"></a>
	<h3>method getChartByIndex <span class="smalllinenumber">[line 559]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>false|<a href="../PHPExcel_Chart/PHPExcel_Chart.html">PHPExcel_Chart</a> getChartByIndex(
[string
$index = null])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get a chart by its index position<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$index</b>&nbsp;&nbsp;</td>
        <td>Chart index position</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetChartByName"></a>
	<h3>method getChartByName <span class="smalllinenumber">[line 597]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>false|<a href="../PHPExcel_Chart/PHPExcel_Chart.html">PHPExcel_Chart</a> getChartByName(
[string
$chartName = ''])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get a chart by name<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$chartName</b>&nbsp;&nbsp;</td>
        <td>Chart name</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetChartCollection"></a>
	<h3>method getChartCollection <span class="smalllinenumber">[line 515]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Chart[] getChartCollection(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get collection of charts<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetChartCount"></a>
	<h3>method getChartCount <span class="smalllinenumber">[line 547]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>int getChartCount(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Return the count of charts on this worksheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>The number of charts</td>
  </tr>
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetChartNames"></a>
	<h3>method getChartNames <span class="smalllinenumber">[line 581]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string[] getChartNames(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Return an array of the names of charts on this worksheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>The names of charts</td>
  </tr>
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetColumnDimension"></a>
	<h3>method getColumnDimension <span class="smalllinenumber">[line 1262]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a> getColumnDimension(
[string
$pColumn = 'A'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get column dimension at a specific column<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>String index of the column</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetColumnDimensionByColumn"></a>
	<h3>method getColumnDimensionByColumn <span class="smalllinenumber">[line 1283]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a> getColumnDimensionByColumn(
[string
$pColumn = 0])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get column dimension at a specific column by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetColumnDimensions"></a>
	<h3>method getColumnDimensions <span class="smalllinenumber">[line 485]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Worksheet_ColumnDimension[] getColumnDimensions(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get collection of column dimensions<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetComment"></a>
	<h3>method getComment <span class="smalllinenumber">[line 2183]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel/PHPExcel_Comment.html">PHPExcel_Comment</a> getComment(
[string
$pCellCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get comment for cell<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
        <td>Cell coordinate to get comment for</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetCommentByColumnAndRow"></a>
	<h3>method getCommentByColumnAndRow <span class="smalllinenumber">[line 2214]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel/PHPExcel_Comment.html">PHPExcel_Comment</a> getCommentByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get comment for cell by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetComments"></a>
	<h3>method getComments <span class="smalllinenumber">[line 2158]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Comment[] getComments(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get comments<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetConditionalStyles"></a>
	<h3>method getConditionalStyles <span class="smalllinenumber">[line 1353]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Style_Conditional[] getConditionalStyles(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get conditional styles for a cell<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetConditionalStylesCollection"></a>
	<h3>method getConditionalStylesCollection <span class="smalllinenumber">[line 1392]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array getConditionalStylesCollection(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get collection of conditional styles<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetDataValidation"></a>
	<h3>method getDataValidation <span class="smalllinenumber">[line 2643]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void getDataValidation(
[string
$pCellCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get data validation<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
        <td>Cell coordinate to get data validation for</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetDataValidationCollection"></a>
	<h3>method getDataValidationCollection <span class="smalllinenumber">[line 2688]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Cell_DataValidation[] getDataValidationCollection(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get collection of data validations<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetDefaultColumnDimension"></a>
	<h3>method getDefaultColumnDimension <span class="smalllinenumber">[line 495]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a> getDefaultColumnDimension(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get default column dimension<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetDefaultRowDimension"></a>
	<h3>method getDefaultRowDimension <span class="smalllinenumber">[line 475]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowDimension.html">PHPExcel_Worksheet_RowDimension</a> getDefaultRowDimension(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get default row dimension<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetDefaultStyle"></a>
	<h3>method getDefaultStyle <span class="smalllinenumber">[line 1305]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getDefaultStyle(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get default style of workbork.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
  </tr>
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetDrawingCollection"></a>
	<h3>method getDrawingCollection <span class="smalllinenumber">[line 505]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Worksheet_BaseDrawing[] getDrawingCollection(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get collection of drawings<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetFreezePane"></a>
	<h3>method getFreezePane <span class="smalllinenumber">[line 1895]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getFreezePane(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get Freeze Pane<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHashCode"></a>
	<h3>method getHashCode <span class="smalllinenumber">[line 2546]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getHashCode(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get hash code<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Hash code</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHeaderFooter"></a>
	<h3>method getHeaderFooter <span class="smalllinenumber">[line 906]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a> getHeaderFooter(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get page header/footer<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHighestColumn"></a>
	<h3>method getHighestColumn <span class="smalllinenumber">[line 974]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getHighestColumn(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get highest worksheet column<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest column name</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHighestDataColumn"></a>
	<h3>method getHighestDataColumn <span class="smalllinenumber">[line 984]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getHighestDataColumn(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get highest worksheet column that contains data<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest column name that contains data</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHighestDataRow"></a>
	<h3>method getHighestDataRow <span class="smalllinenumber">[line 1004]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getHighestDataRow(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get highest worksheet row that contains data<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest row number that contains data</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHighestRow"></a>
	<h3>method getHighestRow <span class="smalllinenumber">[line 994]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>int getHighestRow(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get highest worksheet row<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest row number</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHighestRowAndColumn"></a>
	<h3>method getHighestRowAndColumn <span class="smalllinenumber">[line 1014]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array getHighestRowAndColumn(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get highest worksheet column and highest row that have cell records<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest column name and highest row number</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHyperlink"></a>
	<h3>method getHyperlink <span class="smalllinenumber">[line 2588]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void getHyperlink(
[string
$pCellCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get hyperlink<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
        <td>Cell coordinate to get hyperlink for</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetHyperlinkCollection"></a>
	<h3>method getHyperlinkCollection <span class="smalllinenumber">[line 2633]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Cell_Hyperlink[] getHyperlinkCollection(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get collection of hyperlinks<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetMergeCells"></a>
	<h3>method getMergeCells <span class="smalllinenumber">[line 1726]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array[] getMergeCells(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get merge cells array.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetPageMargins"></a>
	<h3>method getPageMargins <span class="smalllinenumber">[line 884]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a> getPageMargins(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get page margins<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetPageSetup"></a>
	<h3>method getPageSetup <span class="smalllinenumber">[line 862]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a> getPageSetup(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get page setup<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetParent"></a>
	<h3>method getParent <span class="smalllinenumber">[line 738]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel/PHPExcel.html">PHPExcel</a> getParent(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get parent<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetPrintGridlines"></a>
	<h3>method getPrintGridlines <span class="smalllinenumber">[line 2078]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean getPrintGridlines(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Print gridlines?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetProtectedCells"></a>
	<h3>method getProtectedCells <span class="smalllinenumber">[line 1827]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array[] getProtectedCells(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get protected cells<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetProtection"></a>
	<h3>method getProtection <span class="smalllinenumber">[line 950]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a> getProtection(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get Protection<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetRightToLeft"></a>
	<h3>method getRightToLeft <span class="smalllinenumber">[line 2313]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean getRightToLeft(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get right-to-left<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetRowDimension"></a>
	<h3>method getRowDimension <span class="smalllinenumber">[line 1242]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowDimension.html">PHPExcel_Worksheet_RowDimension</a> getRowDimension(
[int
$pRow = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get row dimension at a specific row<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric index of the row</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetRowDimensions"></a>
	<h3>method getRowDimensions <span class="smalllinenumber">[line 465]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Worksheet_RowDimension[] getRowDimensions(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get collection of row dimensions<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetRowIterator"></a>
	<h3>method getRowIterator <span class="smalllinenumber">[line 2495]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowIterator.html">PHPExcel_Worksheet_RowIterator</a> getRowIterator(
[integer
$startRow = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get row iterator<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">integer&nbsp;&nbsp;</td>
        <td><b>$startRow</b>&nbsp;&nbsp;</td>
        <td>The row number at which to start iterating</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetSelectedCell"></a>
	<h3>method getSelectedCell <span class="smalllinenumber">[line 2225]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getSelectedCell(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get selected cell<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetSelectedCells"></a>
	<h3>method getSelectedCells <span class="smalllinenumber">[line 2245]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getSelectedCells(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get selected cells<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetSheetState"></a>
	<h3>method getSheetState <span class="smalllinenumber">[line 842]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getSheetState(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get sheet state<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Sheet state (visible, hidden, veryHidden)</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetSheetView"></a>
	<h3>method getSheetView <span class="smalllinenumber">[line 928]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a> getSheetView(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get sheet view<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetShowGridlines"></a>
	<h3>method getShowGridlines <span class="smalllinenumber">[line 2058]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean getShowGridlines(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Show gridlines?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetShowRowColHeaders"></a>
	<h3>method getShowRowColHeaders <span class="smalllinenumber">[line 2098]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean getShowRowColHeaders(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Show row and column headers?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetShowSummaryBelow"></a>
	<h3>method getShowSummaryBelow <span class="smalllinenumber">[line 2118]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean getShowSummaryBelow(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Show summary below? (Row/Column outlining)<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetShowSummaryRight"></a>
	<h3>method getShowSummaryRight <span class="smalllinenumber">[line 2138]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean getShowSummaryRight(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Show summary right? (Row/Column outlining)<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetStyle"></a>
	<h3>method getStyle <span class="smalllinenumber">[line 1336]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getStyle(
[string
$pCellCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get style for cell<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
        <td>Cell coordinate to get style for</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetStyleByColumnAndRow"></a>
	<h3>method getStyleByColumnAndRow <span class="smalllinenumber">[line 1417]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getStyleByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get style for cell by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetStyles"></a>
	<h3>method getStyles <span class="smalllinenumber">[line 1293]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>PHPExcel_Style[] getStyles(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get styles<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetTabColor"></a>
	<h3>method getTabColor <span class="smalllinenumber">[line 2726]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Style/PHPExcel_Style_Color.html">PHPExcel_Style_Color</a> getTabColor(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get tab color<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetTitle"></a>
	<h3>method getTitle <span class="smalllinenumber">[line 767]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string getTitle(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get title<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodhyperlinkExists"></a>
	<h3>method hyperlinkExists <span class="smalllinenumber">[line 2623]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean hyperlinkExists(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Hyperlink at a specific coordinate exists?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodinsertNewColumnBefore"></a>
	<h3>method insertNewColumnBefore <span class="smalllinenumber">[line 1974]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> insertNewColumnBefore(
[int
$pBefore = 'A'], [int
$pNumCols = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Insert a new column, updating all possible related data<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pBefore</b>&nbsp;&nbsp;</td>
        <td>Insert before this one</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pNumCols</b>&nbsp;&nbsp;</td>
        <td>Number of columns to insert</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodinsertNewColumnBeforeByIndex"></a>
	<h3>method insertNewColumnBeforeByIndex <span class="smalllinenumber">[line 1992]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> insertNewColumnBeforeByIndex(
[int
$pBefore = 0], [int
$pNumCols = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Insert a new column, updating all possible related data<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pBefore</b>&nbsp;&nbsp;</td>
        <td>Insert before this one (numeric column coordinate of the cell)</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pNumCols</b>&nbsp;&nbsp;</td>
        <td>Number of columns to insert</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodinsertNewRowBefore"></a>
	<h3>method insertNewRowBefore <span class="smalllinenumber">[line 1956]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> insertNewRowBefore(
[int
$pBefore = 1], [int
$pNumRows = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Insert a new row, updating all possible related data<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pBefore</b>&nbsp;&nbsp;</td>
        <td>Insert before this one</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pNumRows</b>&nbsp;&nbsp;</td>
        <td>Number of rows to insert</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodisTabColorSet"></a>
	<h3>method isTabColorSet <span class="smalllinenumber">[line 2752]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>boolean isTabColorSet(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Tab color set?<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodmergeCells"></a>
	<h3>method mergeCells <span class="smalllinenumber">[line 1632]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> mergeCells(
[string
$pRange = 'A1:A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set merge on a cell range<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Cell range (e.g. A1:E1)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodmergeCellsByColumnAndRow"></a>
	<h3>method mergeCellsByColumnAndRow <span class="smalllinenumber">[line 1674]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> mergeCellsByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 1], [int
$pColumn2 = 0], [int
$pRow2 = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set merge on a cell range by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow1</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the last cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow2</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the last cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodnamedRangeToArray"></a>
	<h3>method namedRangeToArray <span class="smalllinenumber">[line 2453]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array namedRangeToArray(
[string
$pNamedRange = ''], [mixed
$nullValue = null], [boolean
$calculateFormulas = true], [boolean
$formatData = true], [boolean
$returnCellRef = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Create array from a range of cells<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pNamedRange</b>&nbsp;&nbsp;</td>
        <td>Name of the Named Range</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$nullValue</b>&nbsp;&nbsp;</td>
        <td>Value returned in the array entry if a cell doesn't exist</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$calculateFormulas</b>&nbsp;&nbsp;</td>
        <td>Should formulas be calculated?</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$formatData</b>&nbsp;&nbsp;</td>
        <td>Should formatting be applied to cell values?</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$returnCellRef</b>&nbsp;&nbsp;</td>
        <td>False - Return a simple array of rows and columns indexed by number counting from zero                                             True - Return rows and columns indexed by their actual row and column IDs</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodprotectCells"></a>
	<h3>method protectCells <span class="smalllinenumber">[line 1753]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> protectCells(
[string
$pRange = 'A1'], [string
$pPassword = ''], [boolean
$pAlreadyHashed = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set protection on a cell range<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Cell (e.g. A1) or cell range (e.g. A1:E1)</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pPassword</b>&nbsp;&nbsp;</td>
        <td>Password to unlock the protection</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pAlreadyHashed</b>&nbsp;&nbsp;</td>
        <td>If the password has already been hashed, set this to true</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodprotectCellsByColumnAndRow"></a>
	<h3>method protectCellsByColumnAndRow <span class="smalllinenumber">[line 1778]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> protectCellsByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 1], [int
$pColumn2 = 0], [int
$pRow2 = 1], [string
$pPassword = ''], [boolean
$pAlreadyHashed = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set protection on a cell range by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow1</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the last cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow2</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the last cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pPassword</b>&nbsp;&nbsp;</td>
        <td>Password to unlock the protection</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pAlreadyHashed</b>&nbsp;&nbsp;</td>
        <td>If the password has already been hashed, set this to true</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodrangeToArray"></a>
	<h3>method rangeToArray <span class="smalllinenumber">[line 2384]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array rangeToArray(
[string
$pRange = 'A1'], [mixed
$nullValue = null], [boolean
$calculateFormulas = true], [boolean
$formatData = true], [boolean
$returnCellRef = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Create array from a range of cells<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$nullValue</b>&nbsp;&nbsp;</td>
        <td>Value returned in the array entry if a cell doesn't exist</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$calculateFormulas</b>&nbsp;&nbsp;</td>
        <td>Should formulas be calculated?</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$formatData</b>&nbsp;&nbsp;</td>
        <td>Should formatting be applied to cell values?</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$returnCellRef</b>&nbsp;&nbsp;</td>
        <td>False - Return a simple array of rows and columns indexed by number counting from zero                                             True - Return rows and columns indexed by their actual row and column IDs</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodrebindParent"></a>
	<h3>method rebindParent <span class="smalllinenumber">[line 748]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> rebindParent(
PHPExcel
$parent)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Re-bind parent<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a>&nbsp;&nbsp;</td>
        <td><b>$parent</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodrefreshColumnDimensions"></a>
	<h3>method refreshColumnDimensions <span class="smalllinenumber">[line 616]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> refreshColumnDimensions(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Refresh column dimensions<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodrefreshRowDimensions"></a>
	<h3>method refreshRowDimensions <span class="smalllinenumber">[line 635]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> refreshRowDimensions(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Refresh row dimensions<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodremoveAutoFilter"></a>
	<h3>method removeAutoFilter <span class="smalllinenumber">[line 1884]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeAutoFilter(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Remove autofilter<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodremoveColumn"></a>
	<h3>method removeColumn <span class="smalllinenumber">[line 2026]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeColumn(
[int
$pColumn = 'A'], [int
$pNumCols = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Remove a column, updating all possible related data<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Remove starting with this one</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pNumCols</b>&nbsp;&nbsp;</td>
        <td>Number of columns to remove</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodremoveColumnByIndex"></a>
	<h3>method removeColumnByIndex <span class="smalllinenumber">[line 2045]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeColumnByIndex(
[int
$pColumn = 0], [int
$pNumCols = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Remove a column, updating all possible related data<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Remove starting with this one (numeric column coordinate of the cell)</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pNumCols</b>&nbsp;&nbsp;</td>
        <td>Number of columns to remove</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodremoveConditionalStyles"></a>
	<h3>method removeConditionalStyles <span class="smalllinenumber">[line 1381]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeConditionalStyles(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Removes conditional styles for a cell<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodremoveRow"></a>
	<h3>method removeRow <span class="smalllinenumber">[line 2008]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeRow(
[int
$pRow = 1], [int
$pNumRows = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Delete a row, updating all possible related data<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Remove starting with this one</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pNumRows</b>&nbsp;&nbsp;</td>
        <td>Number of rows to remove</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodresetTabColor"></a>
	<h3>method resetTabColor <span class="smalllinenumber">[line 2739]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> resetTabColor(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Reset tab color<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetAutoFilter"></a>
	<h3>method setAutoFilter <span class="smalllinenumber">[line 1850]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setAutoFilter(
<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_AutoFilter.html">PHPExcel_Worksheet_AutoFilter</a>|string
$pValue)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set AutoFilter<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_AutoFilter.html">PHPExcel_Worksheet_AutoFilter</a>|string&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>A simple string containing a Cell range like 'A1:E10' is permitted for backward compatibility</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetAutoFilterByColumnAndRow"></a>
	<h3>method setAutoFilterByColumnAndRow <span class="smalllinenumber">[line 1870]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setAutoFilterByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 1], [int
$pColumn2 = 0], [int
$pRow2 = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set Autofilter Range by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow1</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the second cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow2</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the second cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetBreak"></a>
	<h3>method setBreak <span class="smalllinenumber">[line 1587]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setBreak(
[string
$pCell = 'A1'], [int
$pBreak = PHPExcel_Worksheet::BREAK_NONE])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set break on a cell<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCell</b>&nbsp;&nbsp;</td>
        <td>Cell coordinate (e.g. A1)</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pBreak</b>&nbsp;&nbsp;</td>
        <td>Break type (type of PHPExcel_Worksheet::BREAK_*)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetBreakByColumnAndRow"></a>
	<h3>method setBreakByColumnAndRow <span class="smalllinenumber">[line 1610]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setBreakByColumnAndRow(
[integer
$pColumn = 0], [integer
$pRow = 1], [integer
$pBreak = PHPExcel_Worksheet::BREAK_NONE])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set break on a cell by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">integer&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">integer&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">integer&nbsp;&nbsp;</td>
        <td><b>$pBreak</b>&nbsp;&nbsp;</td>
        <td>Break type (type of PHPExcel_Worksheet::BREAK_*)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetCellValue"></a>
	<h3>method setCellValue <span class="smalllinenumber">[line 1027]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>|<a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> setCellValue(
[string
$pCoordinate = 'A1'], [mixed
$pValue = null], [bool
$returnCell = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set a cell value<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Depending on the last parameter being specified</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td>Coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Value of the cell</td>
      </tr>
          <tr>
        <td class="type">bool&nbsp;&nbsp;</td>
        <td><b>$returnCell</b>&nbsp;&nbsp;</td>
        <td>Return the worksheet (false, default) or the cell (true)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetCellValueByColumnAndRow"></a>
	<h3>method setCellValueByColumnAndRow <span class="smalllinenumber">[line 1042]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>|<a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> setCellValueByColumnAndRow(
[string
$pColumn = 0], [string
$pRow = 1], [mixed
$pValue = null], [bool
$returnCell = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set a cell value by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Depending on the last parameter being specified</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Value of the cell</td>
      </tr>
          <tr>
        <td class="type">bool&nbsp;&nbsp;</td>
        <td><b>$returnCell</b>&nbsp;&nbsp;</td>
        <td>Return the worksheet (false, default) or the cell (true)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetCellValueExplicit"></a>
	<h3>method setCellValueExplicit <span class="smalllinenumber">[line 1057]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>|<a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> setCellValueExplicit(
[string
$pCoordinate = 'A1'], [mixed
$pValue = null], [string
$pDataType = PHPExcel_Cell_DataType::TYPE_STRING], [bool
$returnCell = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set a cell value<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Depending on the last parameter being specified</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td>Coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Value of the cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pDataType</b>&nbsp;&nbsp;</td>
        <td>Explicit data type</td>
      </tr>
          <tr>
        <td class="type">bool&nbsp;&nbsp;</td>
        <td><b>$returnCell</b>&nbsp;&nbsp;</td>
        <td>Return the worksheet (false, default) or the cell (true)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetCellValueExplicitByColumnAndRow"></a>
	<h3>method setCellValueExplicitByColumnAndRow <span class="smalllinenumber">[line 1074]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>|<a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> setCellValueExplicitByColumnAndRow(
[string
$pColumn = 0], [string
$pRow = 1], [mixed
$pValue = null], [string
$pDataType = PHPExcel_Cell_DataType::TYPE_STRING], [bool
$returnCell = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set a cell value by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Depending on the last parameter being specified</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Value of the cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pDataType</b>&nbsp;&nbsp;</td>
        <td>Explicit data type</td>
      </tr>
          <tr>
        <td class="type">bool&nbsp;&nbsp;</td>
        <td><b>$returnCell</b>&nbsp;&nbsp;</td>
        <td>Return the worksheet (false, default) or the cell (true)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetComments"></a>
	<h3>method setComments <span class="smalllinenumber">[line 2169]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setComments(
[array
$pValue = array()])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set comments array for the entire sheet.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">array&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>of PHPExcel_Comment</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetConditionalStyles"></a>
	<h3>method setConditionalStyles <span class="smalllinenumber">[line 1404]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setConditionalStyles(
[$pCoordinate
$pCoordinate = 'A1'], $pValue
$pValue)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set conditional styles<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">$pCoordinate&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td>string E.g. 'A1'</td>
      </tr>
          <tr>
        <td class="type">$pValue&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>PHPExcel_Style_Conditional[]</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetDataValidation"></a>
	<h3>method setDataValidation <span class="smalllinenumber">[line 2662]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setDataValidation(
[string
$pCellCoordinate = 'A1'], [PHPExcel_Cell_DataValidation
$pDataValidation = null])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set data validation<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
        <td>Cell coordinate to insert data validation</td>
      </tr>
          <tr>
        <td class="type"><a href="../PHPExcel_Cell/PHPExcel_Cell_DataValidation.html">PHPExcel_Cell_DataValidation</a>&nbsp;&nbsp;</td>
        <td><b>$pDataValidation</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetDefaultStyle"></a>
	<h3>method setDefaultStyle <span class="smalllinenumber">[line 1318]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setDefaultStyle(
PHPExcel_Style
$pValue)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set default style - should only be used by PHPExcel_IReader implementations!<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
  </tr>
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a>&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetHeaderFooter"></a>
	<h3>method setHeaderFooter <span class="smalllinenumber">[line 917]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setHeaderFooter(
<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a>
$pValue)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set page header/footer<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a>&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetHyperlink"></a>
	<h3>method setHyperlink <span class="smalllinenumber">[line 2607]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setHyperlink(
[string
$pCellCoordinate = 'A1'], [PHPExcel_Cell_Hyperlink
$pHyperlink = null])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set hyperlnk<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
        <td>Cell coordinate to insert hyperlink</td>
      </tr>
          <tr>
        <td class="type"><a href="../PHPExcel_Cell/PHPExcel_Cell_Hyperlink.html">PHPExcel_Cell_Hyperlink</a>&nbsp;&nbsp;</td>
        <td><b>$pHyperlink</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetMergeCells"></a>
	<h3>method setMergeCells <span class="smalllinenumber">[line 1737]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void setMergeCells(
[array
$pValue = array()])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set merge cells array for the entire sheet. Use instead mergeCells() to merge  a single cell range.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">array&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetPageMargins"></a>
	<h3>method setPageMargins <span class="smalllinenumber">[line 895]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setPageMargins(
<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a>
$pValue)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set page margins<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a>&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetPageSetup"></a>
	<h3>method setPageSetup <span class="smalllinenumber">[line 873]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setPageSetup(
<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a>
$pValue)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set page setup<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a>&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetPrintGridlines"></a>
	<h3>method setPrintGridlines <span class="smalllinenumber">[line 2088]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setPrintGridlines(
[boolean
$pValue = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set print gridlines<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Print gridlines (true/false)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetProtection"></a>
	<h3>method setProtection <span class="smalllinenumber">[line 961]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setProtection(
<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a>
$pValue)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set Protection<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a>&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetRightToLeft"></a>
	<h3>method setRightToLeft <span class="smalllinenumber">[line 2323]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setRightToLeft(
[boolean
$value = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set right-to-left<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$value</b>&nbsp;&nbsp;</td>
        <td>Right-to-left true/false</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetSelectedCell"></a>
	<h3>method setSelectedCell <span class="smalllinenumber">[line 2256]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSelectedCell(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Selected cell<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td>Cell (i.e. A1)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetSelectedCellByColumnAndRow"></a>
	<h3>method setSelectedCellByColumnAndRow <span class="smalllinenumber">[line 2303]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSelectedCellByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Selected cell by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetSelectedCells"></a>
	<h3>method setSelectedCells <span class="smalllinenumber">[line 2268]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSelectedCells(
[string
$pCoordinate = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Select a range of cells.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
        <td>Cell range, examples: 'A1', 'B2:G5', 'A:C', '3:6'</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetSharedStyle"></a>
	<h3>method setSharedStyle <span class="smalllinenumber">[line 1433]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSharedStyle(
[PHPExcel_Style
$pSharedCellStyle = null], [string
$pRange = ''])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set shared cell style to a range of cells<br /><br /><p>Please note that this will overwrite existing cell styles for cells in range!</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
  </tr>
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a>&nbsp;&nbsp;</td>
        <td><b>$pSharedCellStyle</b>&nbsp;&nbsp;</td>
        <td>Cell style to share</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetSheetState"></a>
	<h3>method setSheetState <span class="smalllinenumber">[line 852]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSheetState(
[string
$value = PHPExcel_Worksheet::SHEETSTATE_VISIBLE])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set sheet state<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$value</b>&nbsp;&nbsp;</td>
        <td>Sheet state (visible, hidden, veryHidden)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetSheetView"></a>
	<h3>method setSheetView <span class="smalllinenumber">[line 939]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSheetView(
<a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_SheetView.html">PHPExcel_Worksheet_SheetView</a>
$pValue)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set sheet view<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_SheetView.html">PHPExcel_Worksheet_SheetView</a>&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetShowGridlines"></a>
	<h3>method setShowGridlines <span class="smalllinenumber">[line 2068]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setShowGridlines(
[boolean
$pValue = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set show gridlines<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Show gridlines (true/false)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetShowRowColHeaders"></a>
	<h3>method setShowRowColHeaders <span class="smalllinenumber">[line 2108]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setShowRowColHeaders(
[boolean
$pValue = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set show row and column headers<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Show row and column headers (true/false)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetShowSummaryBelow"></a>
	<h3>method setShowSummaryBelow <span class="smalllinenumber">[line 2128]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setShowSummaryBelow(
[boolean
$pValue = true])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set show summary below<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Show summary below (true/false)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetShowSummaryRight"></a>
	<h3>method setShowSummaryRight <span class="smalllinenumber">[line 2148]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setShowSummaryRight(
[boolean
$pValue = true])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set show summary right<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>Show summary right (true/false)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsetTitle"></a>
	<h3>method setTitle <span class="smalllinenumber">[line 783]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setTitle(
[string
$pValue = 'Worksheet'], [string
$updateFormulaCellReferences = true])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Set title<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pValue</b>&nbsp;&nbsp;</td>
        <td>String containing the dimension of this worksheet</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$updateFormulaCellReferences</b>&nbsp;&nbsp;</td>
        <td>boolean Flag indicating whether cell references in formulae should                                                     be updated to reflect the new sheet name.                                                     This should be left as the default true, unless you are                                                     certain that no formula cells on any worksheet contain                                                     references to this worksheet</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodshrinkRangeToFit"></a>
	<h3>method shrinkRangeToFit <span class="smalllinenumber">[line 2699]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>string shrinkRangeToFit(
string
$range)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Adjusted range value</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$range</b>&nbsp;&nbsp;</td>
        <td></td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodsortCellCollection"></a>
	<h3>method sortCellCollection <span class="smalllinenumber">[line 452]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> sortCellCollection(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Sort collection of cells<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodtoArray"></a>
	<h3>method toArray <span class="smalllinenumber">[line 2477]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>array toArray(
[mixed
$nullValue = null], [boolean
$calculateFormulas = true], [boolean
$formatData = true], [boolean
$returnCellRef = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Create array from worksheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">mixed&nbsp;&nbsp;</td>
        <td><b>$nullValue</b>&nbsp;&nbsp;</td>
        <td>Value returned in the array entry if a cell doesn't exist</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$calculateFormulas</b>&nbsp;&nbsp;</td>
        <td>Should formulas be calculated?</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$formatData</b>&nbsp;&nbsp;</td>
        <td>Should formatting be applied to cell values?</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$returnCellRef</b>&nbsp;&nbsp;</td>
        <td>False - Return a simple array of rows and columns indexed by number counting from zero                                             True - Return rows and columns indexed by their actual row and column IDs</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodunfreezePane"></a>
	<h3>method unfreezePane <span class="smalllinenumber">[line 1943]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unfreezePane(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Unfreeze Pane<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodunmergeCells"></a>
	<h3>method unmergeCells <span class="smalllinenumber">[line 1687]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unmergeCells(
[string
$pRange = 'A1:A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Remove merge on a cell range<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Cell range (e.g. A1:E1)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodunmergeCellsByColumnAndRow"></a>
	<h3>method unmergeCellsByColumnAndRow <span class="smalllinenumber">[line 1715]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unmergeCellsByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 1], [int
$pColumn2 = 0], [int
$pRow2 = 1])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Remove merge on a cell range by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow1</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the last cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow2</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the last cell</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodunprotectCells"></a>
	<h3>method unprotectCells <span class="smalllinenumber">[line 1791]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unprotectCells(
[string
$pRange = 'A1'])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Remove protection on a cell range<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pRange</b>&nbsp;&nbsp;</td>
        <td>Cell (e.g. A1) or cell range (e.g. A1:E1)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodunprotectCellsByColumnAndRow"></a>
	<h3>method unprotectCellsByColumnAndRow <span class="smalllinenumber">[line 1816]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unprotectCellsByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 1], [int
$pColumn2 = 0], [int
$pRow2 = 1], [string
$pPassword = ''], [boolean
$pAlreadyHashed = false])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Remove protection on a cell range by using numeric cell coordinates<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow1</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the first cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
        <td>Numeric column coordinate of the last cell</td>
      </tr>
          <tr>
        <td class="type">int&nbsp;&nbsp;</td>
        <td><b>$pRow2</b>&nbsp;&nbsp;</td>
        <td>Numeric row coordinate of the last cell</td>
      </tr>
          <tr>
        <td class="type">string&nbsp;&nbsp;</td>
        <td><b>$pPassword</b>&nbsp;&nbsp;</td>
        <td>Password to unlock the protection</td>
      </tr>
          <tr>
        <td class="type">boolean&nbsp;&nbsp;</td>
        <td><b>$pAlreadyHashed</b>&nbsp;&nbsp;</td>
        <td>If the password has already been hashed, set this to true</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="method__clone"></a>
	<h3>method __clone <span class="smalllinenumber">[line 2771]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void __clone(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Implement PHP __clone to create a deep clone, not just a shallow copy.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />

	
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
</div><br />

<hr />
<a name="class_consts"></a>
<h3>Class Constants</h3>
<div class="tags">
	<a name="constBREAK_COLUMN"></a>
	<p></p>
	<h4>BREAK_COLUMN = <span class="value">&nbsp;2</span></h4>
	<p>[line 41]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="constBREAK_NONE"></a>
	<p></p>
	<h4>BREAK_NONE = <span class="value">&nbsp;0</span></h4>
	<p>[line 39]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="constBREAK_ROW"></a>
	<p></p>
	<h4>BREAK_ROW = <span class="value">&nbsp;1</span></h4>
	<p>[line 40]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="constSHEETSTATE_HIDDEN"></a>
	<p></p>
	<h4>SHEETSTATE_HIDDEN = <span class="value">&nbsp;'hidden'</span></h4>
	<p>[line 45]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="constSHEETSTATE_VERYHIDDEN"></a>
	<p></p>
	<h4>SHEETSTATE_VERYHIDDEN = <span class="value">&nbsp;'veryHidden'</span></h4>
	<p>[line 46]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="constSHEETSTATE_VISIBLE"></a>
	<p></p>
	<h4>SHEETSTATE_VISIBLE = <span class="value">&nbsp;'visible'</span></h4>
	<p>[line 44]</p>
  
  <br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
</div><br />

        <div class="credit">
		    <hr />
		    Documentation generated on Fri, 12 Oct 2012 00:18:14 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.4.4</a>
	      </div>
      </td></tr></table>
    </td>
  </tr>
</table>

</body>
</html>